﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'proc_cm_DeleteDailywordQuestion')
BEGIN
    PRINT 'Dropping Procedure proc_cm_DeleteDailywordQuestion'
    DROP  Procedure  proc_cm_DeleteDailywordQuestion
END
GO

PRINT 'Creating Procedure proc_cm_DeleteDailywordQuestion'
GO

CREATE PROCEDURE [dbo].[proc_cm_DeleteDailywordQuestion]
	@pDailywordQuestionId [uniqueidentifier]
AS
BEGIN
	SET NOCOUNT ON

	DELETE FROM [dbo].[tbl_dailyword_question]
	WHERE [dailyword_question_id] = @pDailywordQuestionId
END
GO

GRANT EXEC ON dbo.proc_cm_DeleteDailywordQuestion TO PUBLIC
GO
